package ar.edu.utn.frgp.servicio;

import java.sql.DriverManager;
import com.mysql.jdbc.Connection;

public class ReservaService {

	public void addClientet(String cliente, String paquete){
		String host = "jdbc:mysql://localhost:3306/";
		String user = "root";
		String pass = "admin";
		String dbName = "tpc1_Grupo6";
		
		try{
			Class.forName("com.mysql.jdbc.Driver");				
			Connection conn = (Connection) DriverManager.getConnection(host + dbName, user, pass);
			java.sql.Statement st = conn.createStatement();
			st.executeUpdate("INSERT INTO reservas(idPaquete, idCliente) value( '" + paquete + "', '" + cliente + "')");
		}catch(Exception e){
			e.printStackTrace();
		}
	}
	
}
